{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ポジションサイズの計算","獲得金額の計算","利益計算"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ポジションサイズの計算","index":0,"n_rows":21,"n_cols":20,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,0,8],[3,1,3,5],[3,6,3,10],[3,11,3,13],[3,14,3,16],[3,17,3,19]]}
[null,"EUR/CAD 日足　２０１２年３月～２０１５年３月"]
[]
[]
[null,"エントリー前",null,null,null,null,"決済後",null,null,null,null,"損益pips",null,null,"損切り幅の計算"]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M",1,2,3,null,"エントリー","決済"]
["No","資金","ロスカット","損切り幅","レート","ﾎﾟｼﾞｼｮﾝｻｲｽﾞ","獲得pips","ロット",null,"レート","損益","エントリー","決済","損益","STOP","エントリー","損切り幅","売買","日付","日付"]
[]
[1,500000,0.03,111,96,{"$f":"SUM(B8*C8/D8/E8)","v":1.4076576576576576},200,1.4,100,0.96,{"$f":"SUM(G8*H8*I8*J8)","v":26880},1.31,1.29,{"$f":"SUM(L8-M8)","v":2.0000000000000018E-2},1.3210999999999999,1.31,{"$f":"SUM(O8-P8)","v":1.1099999999999888E-2},"売","2015-03-09","2015-03-14"]
[2,{"$f":"SUM(B8+K8)","v":526880},0.03,112,96,{"$f":"SUM(B9*C9/D9/E9)","v":1.4700892857142858},562,1.4,100,0.96,{"$f":"SUM(G9*H9*I9*J9)","v":75532.800000000003},1.284,1.2278,{"$f":"SUM(L9-M9)","v":5.6200000000000028E-2},1.296,1.2847999999999999,{"$f":"SUM(O9-P9)","v":1.1200000000000099E-2},"売","2015-07-02","2015-08-02"]
[3,602412.80000000005,0.03,93,96,2.0242365591397853,263,2,100,0.96,50496,1.2515000000000001,1.2778,{"$f":"SUM(M10-L10)","v":2.629999999999999E-2},1.2422,1.2515000000000001,{"$f":"SUM(P10-O10)","v":9.300000000000086E-3},"買","2015-09-12","2015-09-18"]
[4,652908.80000000005,0.03,55,96,3.7097090909090906,275,3.7,100,0.96,97680,1.2705,1.298,2.750000000000008E-2,1.2649999999999999,1.2705,{"$f":"SUM(P11-O11)","v":5.5000000000000604E-3},"買","2015-10-16","2015-10-23"]
[5,750588.8,0.03,60,96,3.9093166666666668,281,3.9,100,0.96,105206.39999999998,1.2887,1.3168,2.8100000000000014E-2,1.2827,1.2887,{"$f":"SUM(P12-O12)","v":6.0000000000000053E-3},"買","2015-12-14","2015-12-31"]
[6,855795.20000000007,0.03,86,96,3.1097209302325584,241,3.1,100,0.96,71721.599999999991,1.3520000000000001,1.3761000000000001,2.410000000000001E-2,1.3433999999999999,1.3520000000000001,{"$f":"SUM(P13-O13)","v":8.6000000000001631E-3},"買","2015-06-11","2015-07-02"]
[7,927516.8,0.03,79,96,3.6689746835443038,384,3.6,100,0.96,132710.39999999999,1.3684000000000001,1.4068000000000001,3.839999999999999E-2,1.3605,1.3684000000000001,{"$f":"SUM(P14-O14)","v":7.9000000000000181E-3},"買","2015-08-02","2015-08-26"]
[8,1060227.2,0.03,73,96,{"$f":"SUM(B15*C15/D15/E15)","v":4.5386438356164378},545,4.5,100,0.96,235440,1.39,1.4444999999999999,5.4499999999999993E-2,1.3827,1.39,{"$f":"SUM(P15-O15)","v":7.2999999999998622E-3},"買","2015-09-25","2015-10-26"]
[9,1295667.2,0.03,69,96,5.8680579710144913,416,5.8,100,0.96,231628.79999999996,1.4117,1.4533,4.1600000000000081E-2,1.4048,1.4117,6.8999999999999062E-3,"買","2015-11-14","2015-12-23"]
[10,1527296,0.03,89,96,5.3626966292134837,-89,5.3,100,0.96,-45283.199999999997,1.5243,1.5154000000000001,-8.899999999999908E-3,1.5154000000000001,1.5243,8.899999999999908E-3,"買","2015-02-27","2015-03-05"]
[11,1482012.8,0.03,76,96,6.0938026315789466,295,6,100,0.96,169920,1.1499999999999999,1.4450000000000001,0.29500000000000015,1.5256000000000001,1.518,{"$f":"SUM(O18-P18)","v":7.6000000000000512E-3},"売","2015-05-02","2015-07-03"]
[12,1651932.8,0.03,50,96,10.324579999999999,440,10,100,0.96,422400,1.452,1.4079999999999999,{"$f":"SUM(L19-M19)","v":4.4000000000000039E-2},1.4570000000000001,1.452,{"$f":"SUM(O19-P19)","v":5.0000000000001155E-3},"売","2015-08-22","2015-09-04"]
[13,2074332.8,0.03,77,96,8.4185584415584405,315,8.4,100,0.96,254016,1.4132,1.3816999999999999,{"$f":"SUM(L20-M20)","v":3.1500000000000083E-2},1.4209000000000001,1.4132,{"$f":"SUM(O20-P20)","v":7.7000000000000401E-3},"売","2015-12-30","2015-01-15"]
[14,2328348.7999999998,0.03,80,96,9.095112499999999,693,9,100,0.96,598752,1.4127000000000001,1.3433999999999999,6.9300000000000139E-2,1.4207000000000001,1.4127000000000001,8.0000000000000071E-3,"売","2015-03-03","2015-03-11"]

{"sheet":"獲得金額の計算","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["獲得pips","数量",null,"レート","獲得金額円"]
[411,1.3,100,0.96,{"$f":"SUM(A4*B4*C4*D4)","v":51292.800000000003}]
[422,1.2,100,0.96,48614.400000000001]
[77,1,100,0.96,7392]
[2787,0.6,100,0.96,160531.19999999998]
[289.2,1.1000000000000001,100,0.96,30539.52]
[220.8,0.8,100,0.96,16957.439999999999]
[745,2.6,100,0.96,185952]
[213,0.5,100,0.96,10224]
[304,1.8,100,0.96,52531.200000000004]
[566,0.5,100,0.96,27168]
[306,3,100,0.96,88128]
[772,0.5,100,0.96,37056]
[1551,0.5,100,0.96,74448]
[]
[null,null,null,null,{"$f":"SUM(E4:E16)","v":790834.56}]
[]
[]
[]
[]
[402,1.5,100,null,{"$f":"SUM(A23*B23*C23)","v":60300}]
[221,1.5,100,null,{"$f":"SUM(A24*B24*C24)","v":33150}]
[882,1.3,100,null,114660.00000000001]
[493,0.6,100,null,29580]
[669,1,100,null,66900]
[169,5,100,null,84500]
[115,6.2,100,null,71300]

{"sheet":"利益計算","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"エントリー","決済","損益","獲得pips",null,"STOP","エントリー","損切り"]
[1]
[2,1.3886000000000001,1.3474999999999999,{"$f":"SUM(B4-C4)","v":4.1100000000000136E-2},{"$f":"SUM(D4*10000)","v":411.00000000000136}]
[3,1.3227,1.2805,{"$f":"SUM(B5-C5)","v":4.2200000000000015E-2},422]
[4,1.3184800000000001,1.3107800000000001,{"$f":"SUM(B6-C6)","v":7.7000000000000401E-3},77]
[5,1.5447,1.266,{"$f":"SUM(B7-C7)","v":0.27869999999999995},2787,null,1.57,1.5447,{"$f":"SUM(G7-H7)","v":2.53000000000001E-2}]
[6,1.3687,1.3976200000000001,{"$f":"SUM(C8-B8)","v":2.8920000000000057E-2},289.2,"買い",1.355,1.3687,{"$f":"SUM(H8-G8)","v":1.3700000000000045E-2}]
[7,1.3893,1.3672200000000001,{"$f":"SUM(B9-C9)","v":2.2079999999999878E-2},220.8,null,1.4068000000000001,1.3893,{"$f":"SUM(G9-H9)","v":1.7500000000000071E-2}]
[8,121.61,125.63,{"$f":"SUM(C10-B10)","v":4.019999999999996},402,"買い",120.64,121.61,{"$f":"SUM(H10-G10)","v":0.96999999999999886},"買い"]
[9,122.79,120.58,2.210000000000008,221,null,123.74,122.79,{"$f":"SUM(G11-H11)","v":0.94999999999998863}]
[10,1.5447,1.266,0.27869999999999995,2787,null,1.2158,1.2441,{"$f":"SUM(H12-G12)","v":2.8299999999999992E-2},"買い"]
[null,1.2228000000000001,1.2441,{"$f":"SUM(C13-B13)","v":2.1299999999999875E-2},213,"買い",1.2410000000000001,1.2494000000000001,{"$f":"SUM(H13-G13)","v":8.3999999999999631E-3},"買い"]
[null,1.2490000000000001,1.2794000000000001,{"$f":"SUM(C14-B14)","v":3.0399999999999983E-2},304,"買い",1.2643,1.2694000000000001,{"$f":"SUM(H14-G14)","v":5.1000000000001044E-3},"買い"]
[null,1.2228000000000001,1.2794000000000001,{"$f":"SUM(C15-B15)","v":5.6599999999999984E-2},566,"買い",186.95,185.82,{"$f":"SUM(H15-G15)","v":-1.1299999999999955}]
[null,1.2694000000000001,1.3,{"$f":"SUM(C16-B16)","v":3.0599999999999961E-2},306,"買い",121.73,121.49,{"$f":"SUM(H16-G16)","v":-0.24000000000000909}]
[null,1.2228000000000001,1.3,{"$f":"SUM(C17-B17)","v":7.7199999999999935E-2},772,"買い"]
[null,185.82,177,{"$f":"SUM(B18-C18)","v":8.8199999999999932},882,"売り"]
[null,179.87,184.8,{"$f":"SUM(B19-C19)","v":-4.9300000000000068},493,"買い"]
[null,182.45,175.76,{"$f":"SUM(B20-C20)","v":6.6899999999999977},669,"売り"]